Libris Britannia 4/science library(b).zip/science library(b)/PROGRAMM/TUTORIAL/0222.ZIP/DEMO.CAS

Javelin Case Study | 1986-01-15 | 138KB | 1,524 lines

~0Copyright (c) 1985 Javelin Software Corporation.
S/N   0112345679
Press [F1] for Help.
Version E4.109
Diagram view
Table view
READY
WAIT
 158K
READY
Diagram view
&The Javelin Demonstration
 For the next fifteen minutes, you will see a demonstration of Javelin,
 a business and analysis product that represents a revolutionary advance
 in the way business people organize and report information.
 $}7%You can set up this demonstration to run automatically.
 $}6$
 Wait for sixty seconds without pressing a key; after
 $}3$that time, the demonstration will run automatically
 $}!$until you press [Esc] to stop it.
 $}5%Or...you can view this demonstration at your own pace
.%.%.%
 $}/$
 Press [Space] when you are ready to continue.
 $}0$
 Press [PgUp] to return to the previous screen.
 $}4$
 Press [Esc] at any time to quit and return to DOS.
 $}<%Press [Space] now to see the demonstration at your own pace.
Introducing Javelin
~D   Javelin is a revolutionary software product specifically designed
~C   for business analysis and reporting. Javelin goes far beyond the
~F   capabilities of spreadsheets, helping you to work more efficiently.
 Javelin saves you time
 Javelin eliminates errors
 Javelin helps you communicate
%your findings
~=Unlike a spreadsheet, Javelin can always answer the question,
~""Where did that number come from?"
~=As a result, you are more productive and have more confidence
in your work.
Two features of Javelin'}($s design make it fundamentally different
~(from any other business analysis product
 The Central Information Base
Javelin stores information in
a central information base of
variables, rather than in a
grid of spreadsheet cells.
Central
   Information
 The Ten Javelin Views
You can examine the numbers or
relationships in the central
~ information base from any of ten
vantage points, or
%views~
Diagram view
Worksheet view
Formulas view
Graph view
Table view
Notes view
Chart view
Macro view
Quick graph view
Errors view
}D%When you change information in one view, you also change the central
}D%information base, so every view instantly shows the new information.
~=In this demonstration you will see a real-life application of
 $}=$Javelin's unique approach to business analysis and reporting.
~;You will see many Javelin features in the next few minutes.
    ~:Keep in mind that Javelin is designed so that you can work
~;in whatever way you are most comfortable; you don't need to
~4master every Javelin view or feature to benefit from
~6Javelin's revolutionary approach to business analysis.
}.%Now watch to see how Javelin can work for you.
Diagram view
&Javelin Uses your Language
 Let's start by defining a
   simple relationship:
 $ $ $}
%Total Revenues =
%Total Sales + Parts + Service
 We just typed a formula
  (you can see it on the top
line of the screen).
The formula uses natural
variable names like
%Total Revenues~
%Total Sales~
&The Diagram View
 When you enter the formula,
you see Javelin's Diagram
view come to life.
Service
Parts
 Total Revenues
Total Sales
Total Revenues = Total Sal
 Instantly you see a diagram
  of the variable }
%Total Revenues~
The variables that affect the
value of
%Total Revenues~
shown to the left.
 Below the
   diagram,
   you see the
   formula for
es + Parts + Service~
 $ $ $}
%Total
 $ $ $}
%Revenues~
 Let's add another formula:
 $ $ $}
%Total Sales =
%East Sales + West Sales
As soon as we enter the
formula
West Sales
 Total Sales
Total Revenues
East Sales
Total Sales = East
The Diagram view zooms in
o$n$ $}
%Total Sales~
 Finally, let's enter a
  formula for }
%East Sales~
Toronto Sales
NY Sales
 East
Total Sal
Chicago Sales
~#East Sales = Chicago Sales + NY Sal
 As you define variables,
the Diagram view maps the
new relationships.
 You can trac}
$e connections
among variables by moving
  through the diagram.
Total Sales = East Sales +
West Sales
 Total
Total Revenu
East Sales
Total Revenues = Total
Service
Parts
 Total Revenues
Total Sales
&Easy-to-Use Command Menus
 Let's see another Javelin
   view, the }
%Formulas view~
To see a different view, you
use Javelin's View command.
  DEFINE   CLEAR
 WINDOW }
  PRINT
MENU
Set up or change windows.=
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
Show diagram in current window.`
 All Javelin commands are in
  easy-to-use }
%menus~
 Branches
 Roots
 Formulas ...
Show all formulas.
 Javelin helps you use menus
by giving a description of
the current command on the
top line of the screen.
~    Worksheet
Quick graph
Chart
Table
Formulas ...
Diagram
READY
    Formulas for all variables:
West Sales =
 UNDEFINED
Total Sales = East Sales + West Sales
Total Revenues = Total Sales + Parts + Service
Toronto
 UNDEFINED
Service =
 UNDEFINED
Parts =
 UNDEFINED
NY Sales =
 UNDEFINED
East Sales = Chicago Sales + NY Sales + Toronto Sales
Chicago Sales =
 UNDEFINED
&The Formulas View
 In the Formu}
$las view you can
see all the formulas you have
  entered...
Or you can focus on formulas
that affect a given variable.
WAIT
READY
 Service =
 UNDEFINED
 Parts =
 UNDEFINED
 West Sal
 UNDEFINED
 Toronto Sales =
 UNDEFINED
 NY Sales =
 UNDEFINED
 Chicago Sales =
 UNDEFINED
 East Sales = Chicago Sales + NY Sales + Toronto Sales
 Total Sales = East
West Sales
~.Total Revenues = Total Sales + Parts + Service
 that affect Total Revenues:
 For e}
$xample, these are a
the formulas that affect
 $ $}
%Total Revenues~
 With the Formulas view, you
can see exactly how any given
variable is calculated.
 Now we want to enter data
$for some variables.
  DEFINE   CLEAR
VIEW
WINDOW   PRINT
*ROOTS
MENU
Select view for current window.I
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
~&Show all formulas, roots, or branches.9
~#   Show table of data for variable.
We'll use the View command
again to see the
%Table view~
DEFINED
FINED
 UNDEFINED
les =
 UNDEFINED
 UNDEFINED
les =
 UNDEFINED
 Chicago Sales + N
East Sales + West
 Total Sales + Par
}6    Formulas for all variables that affect Total Revenues:
Variable name (Total Revenues):
 At the top of the screen,
  Javelin prompts for the name
of the variable we want to s
in the Table view.
 We can use Javelin's unique
}    %SPELL key~
 to help us enter
the name of the variable.
&The SPELL Key
 The SPELL key is the key on
the keyboard marked [
]. Any
time you are entering a name,
  you can press [
] to see a
$list of the possibilities.
 Watch the top of the screen
  as we press the SPELL key
WAIT
 West Sales
 Total Sales
 Total Revenues
 Toronto Sales
 Service
 Parts
 NY Sales
 East Sales
 Chicago Sales
 POSSIBILITIES
READYi
On the screen you see a list
of all the variables you might
want to see in the Table view.
By moving a cursor through
the list, we can select any
~    variable.
We'll select
%Chicago Sales~
WAIT
 + NY Sales + Toro
est Sales
 Parts + Service
    t affect Total Rev
Chicago Sales
MENU
READY
Aug 1987
  Apr 1989
Jul 1987
  Mar 1989
Jun 1987
  Feb 1989
May 1987
  Jan 1989
Apr 1987
  Dec 1988
Mar 1987
  Nov 1988
Feb 1987
  Oct 1988
Jan 1987
  Sep 1988
Dec 1986
  Aug 1988
Nov 1986
  Jul 1988
Oct 1986
  Jun 1988
  Feb 1990
Sep 1986
  May 1988
  Jan 1990
Aug 1986
  Apr 1988
  Dec 1989
Jul 1986
  Mar 1988
  Nov 1989
Jun 1986
  Feb 1988
  Oct 1989
May 1986
  Jan 1988
  Sep 1989
Apr 1986
  Dec 1987
  Aug 1989
Mar 1986
  Nov 1987
  Jul 1989
Feb 1986
  Oct 1987
  Jun 1989
Jan 1986
  Sep 1987
  May 1989
Chicago Sales =
 UNDEFINED
&The Table View
 The Table view shows a table
of data for a given variable,
in this case
%Chicago Sales~
%Chicago Sales}
$ is a monthly
variable. However, you can also
~   have daily, weekly, quarterly,
r yearly variables, or var-
ables that r}
$emain constant.
%Javelin has a built-in
%understanding of time.
$The Table view is ideal for
reviewing long columns of
data, or for entering data
quickly and efficiently.
Watch as we enter some
numbers for
%Chicago Sales
~=Chicago Sales =
 Monthly data: January 1986 - January 1986
February 1986
... 1146
~< Chicago Sales =
 Monthly data: January 1986 - March 1986
... 1195
April
... 1258
~; Chicago Sales =
 Monthly data: January 1986 - May 1986
... 1310
June 1986
... 1482
 Using the Table view, we just
entered six months of
for }
%Chicago Sales~
The Table view is only one way
to enter data in Javelin.
Let's use another Javelin view
to enter data for }
%NY Sales~
 You can use the Chart view or
the Quick graph view to enter
%graphically~
WAIT
MENU
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
  DEFINE
VIEW
WINDOW   PRINT
~$Show bar chart of data for variable.
&The Chart View
 The Chart view sho}
$ws data
graphically, even on
  non-graphics monitors.
  Sep 19
  Aug 19
  Jul 19
  Jun 19
  May 19
  Apr 19
  Mar 19
.. 1482
  Feb 19
.. 1310
  Jan 19
.. 1258
  Dec 19
.. 1195
  Nov 19
.. 1146
  Oct 19
... 937
  Sep 19
Chicago Sales =
 Monthly data: January 1986 - June 1986
Variable name (Chicago Sales):
 Once again, let's use the
  SPELL key, [
], to enter
the name of the variable we
want to see, in this case,
%NY Sales~
WAIT
 West Sales
 Total Sales
 Total Revenues
 Toronto Sales
 Service
 Parts
 NY Sales
 East Sales
 Chicago Sales
 POSSIBILITIES
READY
WAIT
ul 1988
un 1988
ay 1988
pr 1988
ar 1988
eb 1988
an 1988
ec 1987
ov 1987
ct 1987
ep 1987
Monthly data: Janu
NY Sales
MENU
READY
J F M A M J J A S O N D J F M A
100
110
120
130
140
150
160
170
180
NY Sales =
 UNDEFINED
This is the Chart view of
%NY Sales~
. The chart is empty,
since }
%NY Sales~
 does not have
any data yet.
o show how the Chart view
$works, we'll split the screen
into t}
$wo parts, or }
%windows~
  DEFINE   CLEAR
VIEW
WINDOW   PRINT
MENU
Select view for current window.
 Adjust
 Switch
 2 windows
 1 window
 WINDOW
Show only one window.
a second
NY Sales =
 UNDEFINED
READY
J F M A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S
  0
120
NY Sales =
 Now we'll put the Table view
o$f$ $}
%NY Sales~
 in the top window.
WAIT
READY
Sep 1986
  Jun 1987
  Mar 1988
Aug 1986
  May 1987
  Feb 1988
Jul 1986
  Apr 1987
  Jan 1988
Jun 1986
  Mar 1987
  Dec 1987
May 1986
  Feb 1987
  Nov 1987
Apr 1986
  Jan 1987
  Oct 1987
Mar 1986
  Dec 1986
  Sep 1987
Feb 1986
  Nov 1986
  Aug 1987
Jan 1986
  Oct 1986
  Jul 1987
NY Sales =
 UNDEFINED
 The screen now shows the
  Table view in the top window,
and the Chart view in the
bottom window.
 By using two windows, you gain
two perspectives on the data
and formulas in your model.
 Watch the Chart view as we
enter the January value of
%NY Sales~
~8NY Sales =
 Monthly data: January 1986 - January 1986
... 1036
NY Sales =
 Monthly data: J
 When we entered the number,
The Chart view drew a bar
corresponding to the value.
As we enter more numbers in
the Table view, Javelin
$automatically shows the new
data in the chart below.
~.NY Sales =
 Monthly data: January 1986 - Febr
... 1250
NY Sales =
 Monthly data: Ja
~9  NY Sales =
 Monthly data: January 1986 - March 1986
... 1468
  NY Sales =
 Monthly data:
In addition to showing data,
Chart
 gives you a way
t$o$ $}
%enter data graphically~
rawing new bars in the chart.
WAIT X
READY
1468|
 We just moved the cursor to
  the Chart view for }
%NY Sales~
$Watch as we press the
 Pressing
 increased the
height of the bar, increasing
the March value of
%NY Sales~
 Now watch as we dra}
$w new bars
in the Chart view
April
... 1593
 NY Sales =
 Monthly data:
~6 NY Sales =
 Monthly data: January 1986 - May 1986
... 1458
NY Sales =
 Monthly data:
~.NY Sales =
 Monthly data: January 1986 - June
... 1728
 Simply by using the arrow
keys, we entered sales data
for April, May, and June.
When we changed data in the
Chart view, Javelin updated
the central information base,
  and displayed the updated
numbers in the Table view.
WAIT
MENU
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
  DEFINE   CLEAR
VIEW
WINDOW   PRINT
~0Show high-resolution graph of data for variable.
January 1986 - June 1986
&The Quick Graph View
 Another way to look at or
   change data graphically is
   with the Quick graph view.
M J J~
NY Sales =
 Month
  Jun 19
  May 19
  Apr 19
.. 1873
  Mar 19
.. 1728
  Feb 19
.. 1458
  Jan 19
.. 1593
  Dec 19
.. 1250
  Nov 19
.. 1036
  Oct 19
NY Sales =
 Monthly data: January 1986 - June 1986
Variable name (NY Sales):
READY#
@xx(>
px`0x
|f0|f0
f|ff/
@`0F9
|f0/;
@0F9
@0`x:
@0xxl0
@xp|lx
f|ffd
x0|f0
@0xx8H
x0|f0
x0x|_
@0xx8J
@x||p
|x0x|
.# @a
@|xx|x
ff00d
D8    @0
@0`{:
0x`0x
x0x|T
@0xxl
Aug 1987
  Apr 1989
Jul 1987
  Mar 1989
Jun 1987
  Feb 1989
May 1987
  Jan 1989
Apr 1987
  Dec 1988
Mar 1987
  Nov 1988
Feb 1987
  Oct 1988
Jan 1987
  Sep 1988
Dec 1986
  Aug 1988
  Apr 1990
Nov 1986
  Jul 1988
  Mar 1990
Oct 1986
  Jun 1988
  Feb 1990
  Jan 1990
  Dec
  Nov
. 926
  Oct
  Sep
. 614
  Aug
. 638
  Jul
. 542
  Jun
. 590
  May
~:Toronto Sales =
 Monthly data: January 1986 - June 1986
...you see that the
  same data we entered
in the Quick graph
view is also shown in
the Table view.
WAIT
READY
 Now that we have entered
les data for thr
variables, we would like
to create a report to
summarize the information.
&The Worksheet View
 Javelin's Worksheet view is
   ideal for creating flexible
   row-and-column reports.
  DEFINE   CLEAR
VIEW
WINDOW   PRINT
MENU
Select view for current window.=
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
Show table of data for variable7
~$Show bar chart of data for variable.C
~0Show high-resolution graph of data for variable.<
~#Show a worksheet in current window.
 We'll use the View Worksheet
command to create a worksheet.
  Sep 19
  Aug 19
  Jul 19
  Jun 19
  May 19
  Apr 19
  Mar 19
... 926
  Feb 19
... 758
  Jan 19
... 614
  Dec 19
... 638
  Nov 19
... 542
  Oct 19
... 590
  Sep 19
Toronto Sales =
 Monthly data: January 1986 - June 1986
Worksheet name:
 Javelin lets you have as many
  worksheets as you want, with
names that you choose.
 Let's call this worksheet
%Revenues Summary~
READY
Revenues Summary
 The left and top edges of the
  worksheet are called borders.
The rest of the worksheet is
made up of cells.
%In a worksheet, what you type
%in the borders determines
%what you see in the cells.
Let's start by entering names
in the left border.
 We'll enter the names of the
three cities for which we have
data, and the name
%East~
 to get
the East total.
Sales
Chicago
Toronto
 Notice that we indented the
names of the cities under the
  heading }
%Sales~
 Javelin automatically combines
the heading and subheadings to
identify the variable names.
To see sales data, we need to
enter dates in the top border.
 Watch the worksheet as we
enter the first three months
of 1986 in the top border.
Jan 1986
Feb 1986
Mar 1986
 The worksheet automatically
  reports data for the dates
and variables we requested.
Because the numbers are
already part of the central
information base, we didn't
need to re-enter any data.
 If we enter dates other than
months in the border, Javelin
automatically converts the
data to
dates we request.
For example, when we enter
1 Q 1986 in the border...
1 Q 1986
Javelin totals the data for
the first quarter.
When we enter the date 1986
in the border...
20334
Javelin totals the data for
the whole year.
In Javelin, you can create as
many worksheets as you want.
Let's view a second worksheet
to look at sales figures in a
different way.
WAIT
READY
Toronto
Chicago
Sales
-Jan 1986
-Feb 1986
Revenues Su
A Different Look at Sales
 Remember that data is stored
~   in a central information base,
not in the cells of any one
worksheet.
This means we can show the
same data on both worksheets
without re-entering numbers.
 In the second worksheet, we'
put variable names across the
top border.
  DEFINE   CLEAR
VIEW
WINDOW   PRINT
*WORKSHEET
MENU
Select view for current window.
 Sort ...
 Exception
 Name change
 Import file ..
 Range ...
 Border ...
 Data copy
 Copy
 *WORKSHEET
Copy contents of cells.
 Shrink border
 Expand border
 Remove border
 Insert border
 Variable names
 Dates
 Border ...
Enter dates in current border.
  Add a row to a top border.
 Sort ...
 Exception
 Name change
 Import file
 Range ...
 Border ...
 Data copy
 Copy
A Different Look at Sales
READY
Sales
Sales
Sales
Sales
Chicago
Toronto
Sales
Sales
 Now watch as we enter dates
in the left border
Jan 1986
Feb 1986
Mar 1986
1 Q 1986
1 Q 1986
 We now have two different
  reports of the same data.
 We created these reports
without re-typing a single
number. Instead, we simply
entered names and dates in
the worksheet borders.
WAIT B
READY
~!Chicago Sales @ January 1986: 937
 In addition to reporting data,
you can also use Javelin
  worksheets to enter data.
 Watch what happens if we type
the value 785 for
%Chicago Sales
in January.
Chicago Sales @ January 1986:
~!Chicago Sales @ January 1986: 785
WAIT
READY
 When we changed the value of
 $ $}
%Chicago Sales~
 in one worksheet,
we changed the value in the
central information base
~!Chicago Sales @ January 1986: 785V
And Javelin instantly dis-
played the new value in the
other worksheet.
There's much more you can do
$on a Javelin worksheet; you
can add variables, formulas,
and data to your model.
If you like, you can build
an entire analysis starting
from the Worksheet view.
 Let's create a worksheet
mmary~
   to show an entirely
-Mar 1~
   different application: a
   cost per unit analysis.
  DEFINE   CLEAR
WINDOW   PRINT
 *WORKSHEET
MENU
~"Commands specific to current view.C
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
~#Show a worksheet in current window.
}    - Jan 1986
-Feb
}    -  Chicago
-Sale
A Different Look at Sales
~"Worksheet name (Revenues Summary):
We'll call this worksheet
%Margin Analysis~
READY
Margin Analysis
WAIT
READY
First, let's enter names
for the new variables in
the left and top borders.
Desks
Chairs
~    Unit Cost
~    Materials
Labor
Total
Total
 When we enter numbers in
the worksheet, the new
variables becomes part of
the central information
base of the model.
Unit Cost Total Desks:
Labor
Materials Desks:
Unit Cost Materials Desks:
45.72
Unit Cost Materials Chairs:
Unit Cost Materials Chairs:
49.29
~!Unit Cost Materials Chairs: 49.29
Desks: 45.72
Labor Desks:
Unit Cost Labor Desks:
37.14
Unit Cost Labor Chairs:
Unit Cost Labor Chairs:
28.82
Unit Cost Labor Chairs: 28.82
Notice that these var-
iables are
n%o%t%~
 based
on any time periods.
%Javelin is well-suited
%for analyzing information
%that is not time-oriented,
%as well as information
%that changes over time.
Just as we entered data,
we can ente}
$r a formula to
define the total cost per
unit for desks
Desks: 37.14
Total
Unit Cost Total Desks:
POINT
Unit Cost Total Desks
Unit Cost Labor Desks
Unit Cost Materials Desks
Unit Cost Labor Desks
READY
#CALC
~FUnit Cost Total Desks: Unit Cost Materials Desks+Unit Cost Labor Desks
%copy~
 that formula to
define the total cost per
unit for chairs.
 DEFINE }
  CLEAR
WINDOW   PRINT
*WORKSHEET
MENU
~O  Define variable, building block, worksheet, graph, macro, time pd., settings.
 Name change
 Import file ..
 Range ...
 Border ...
 Data copy
 Copy
 *WORKSHEET
Change width of current column.
Copy contents of cells.
-   Sales
-East
A Different Look at Sales
READY
POINT
~FSpecify range to copy from: move to corner of range and press . or
READY
POINT
~.to: move to corner of range and press . or
READY
WAIT
#CALC
READY
~FUnit Cost Total Desks: Unit Cost Materials Desks+Unit Cost Labor Desks
~9Chairs: Unit Cost Materials Chairs+Unit Cost Labor Chairs
The #CALC messages on the
orksheet mean that we
need to }    %calculate~
model to see the answers.
WAIT
82.86
READYs
When we press the [F9]
key, Javelin calculates
the total cost per unit
for the desks and chairs.
%Because you can have as
%many worksheets as you
%want, you can prepare
%reports to analyze any
%aspect of your business.
 Suppose you want to see
   where a particular number
   came from. With Javelin,
   you can show the Worksheet
   view in one window and the
   Formulas view in the other
   window, then put the two
   windows
%in sync~
WAIT
READY
Chicago Sales =
 Monthly data: January 198
}+    Formulas for all variables that affect Chic
~!Chicago Sales @ January 1986: 785
 Now, you simply move the
ursor around the worksheet
to see how any number is
calculated.
WAIT
~+NY Sales =
 Monthly data: January 1986 - J
READY
NY Sales @ January 1986: 1036
WAIT
~+Toronto Sales =
 Monthly data: January 198
READY
~!Toronto Sales @ January 1986: 590
WAIT
 Toronto Sales =
 Monthly data: January 1
 NY Sales =
 Monthly data: January 1986 -
 Chicago Sales =
 Monthly data: January 1
~+East Sales = Chicago Sales + NY Sales + Tor
READY
~4East Sales: Chicago Sales + NY Sales + Toronto Sales
What if you want to record
information about a variable,
such as how you estimated its
value, or where the figures
were obtained?
&The Notes View
 Javelin's Notes view gives you
pace to record notes for any
riable in your analysis.
WAIT
READY
/Notes for Toronto Sales:
 Let's leave a
   note to describe
   how we estimated
 $ $ $}
%Toronto Sales
 By adding notes
  for variables
you can make
your work }
%self-~
documenting}
WAIT
READY
~4East Sales: Chicago Sales + NY Sales + Toronto Sales
 Javelin also helps
   you communicate
   your findings by
   providing a simple
   means for creating
   presentation-quality
   graphs in seconds.
 $ $ $}
&The Graph View
 The Graph view is
for creating and
displaying high-
resolution graphs
of data for up to
seven variables.
WAIT
MENU
 Settings
 Configuration
 Printer
 Time period
 Macro ...
 Graph
 Worksheet
 Building block
 Variable
 DEFINE
 DEFINE }
  CLEAR
WINDOW   PRINT
*WORKSHEET
~.Create a graph or change its name or settings.x
 Using the Define
  Graph command, you
~    e as many
graphs as you like.
-1 Q 1986
-Mar 1986
-Feb 1986
-Jan 1986
A Different Look at Sales
Graph name:
Let's create a graph
called
%East Region~
 "}    "Variables
"Legends
 Min {}
 Y-axis {}
 XY plot
 Max {}
 X-axis {}
"Right Axis
 Subtitle {}
 Horiz. bar
 Title {}
 "}    "
 % bar
 Min {}
"Labels
 Stack bar
 Max {}
 "}    "Left Axis
 End date {}
 Line
 Begin date {}
"Type
 Name {East Region}
"Time Axis Limits
"Graph
"Graph Settings
~7To save settings and leave settings sheet, press [Esc].
 Javelin shows you a
 $ $}
%settings sheet~
the graph.
To see a graph, a
you have to do is
list the variables
you want to graph.
~7To save settings and leave settings sheet, press [Esc].
" {Chicago Sales}
~7To save settings and leave settings sheet, press [Esc].
" {Chicago}
~7To save settings and leave settings sheet, press [Esc].
" {NY Sales}
~7To save settings and leave settings sheet, press [Esc].
" {New York}
~7To save settings and leave settings sheet, press [Esc].
" {Toronto Sales}
~7To save settings and leave settings sheet, press [Esc].
" {Toronto}
"Axis
 " " "}
 " " "~
 # # #~
 That's it! To s
 " " "~
   the graph, we just
 " " "~
   press the GRAPH
 " " "~
   key, F10...
 " " "~
3sp{:
@<;fA;
@331<
lpxxvx">
|x0x|
xp|px|
@x|lx
f|ffx
 Since all the
  graph settings
are in one place,
you can make
any change in
seconds.
 For example,
we can easily
make }
%East Region
 line graph.
WAIT $
MENU
Now we press [F10]
again to see the
sam}    $e data as
before in a line
graph
lpxxvx'>    @=
@|x||p
@|x||p
|lxx|\
f|ffo
|f0o<
 You add titles,
  legends, or labels
to a graph simply
by entering them
on the Graph
settings sheet.
Title:
~7To save settings and leave settings sheet, press [Esc].
"East Regional Sales}
~    Subtitle:
~7To save settings and leave settings sheet, press [Esc].
"Projected}
 By changing one
setting, we can
see any of the
following types
of graphs...
A stacked bar
graph...
3sp{:
@<;fA;
@331<
lpxxvx">
|x|x0
px`0x
|f0|f0
percent
3sp{:
@<;fA;
@331<
lpxxvx">
|x|x0
px`0x
|f0|f0
 OFF
Date Display
Horizontal Axis
Date {}
   Date Shown
horizontal
~    bar graph
        @ff0
@|0|M
@0xx8r
lpxxvx
5    @0x
16    @xx
a<    @`
0vxvx
px`0x|_
|f0|f0
Wedge
 OFF Value
 OFF %
 Number Display
Or a pie chart.
@0xx8r
@z""/
|x|x0
px`0x
|f0|f0
@`0K9
WAIT
READY
 Edit curve
 Select period
 Connect to variables
Time Delay
Collections
&Javelin Building Blocks
 Building blocks represent
   universal business
   calculations--such as time
   delays or consolidations
   in a simple, compact form.
0  1  2  3  4  5  6  7  8  9
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
TIME DELAY CURVE: Collections
~MTo return to Diagram view, press [Esc]. To rescale curve to 100%, press [F9].
Curve sums to 0
0  periods dela
&The Time Delay Building Block
With the Time delay building
block, you draw a curve to
show how one variable has a
ed effect on another,
like the effect of Sales on
Collections.
WAIT
READY
 Import values
 Select variab
 Edit org chart
Rollup
United
 $ $~
The Rollup Building Block
Rollup building block
you build an organizational
chart to tell Javelin how to
consolidate data.
~GTo return to Diagram view, press [Esc]. To insert new box, press [Ins].
United
~#Creating new box below current box.
Name:
~GTo return to Diagram view, press [Esc]. To insert new box, press [Ins].
~5Creating new box: press
, or
 to show direction.
 to left of current box.
Name:
~GTo return to Diagram view, press [Esc]. To insert new box, press [Ins].
~5Creating new box: press
, or
 to show direction.
 below current box.
Name:
~GTo return to Diagram view, press [Esc]. To insert new box, press [Ins].
Chicago
~5Creating new box: press
, or
 to show direction.
 to right of current box.
Name:
~GTo return to Diagram view, press [Esc]. To insert new box, press [Ins].
Chicago
~5Creating new box: press
, or
 to show direction.
 to right of current box.
Name:
~GTo return to Diagram view, press [Esc]. To insert new box, press [Ins].
Chicago
   Toronto
 The Rollup building
   block provides a way
   to consolidate data
   from several Javelin
   models.
 Import values
 Select variables
 Edit org chart
Rollup
United
Javelin provides thr
other building blocks:
 Lookup Table
 Import Data
 Curve
 $}(%What you have seen is only the beginning
.%.%.%
~:Javelin has additional features that make it ideal for any
~7application -- from finance to marketing to operations:
 Automatic transfer of data from Lotus 1-2-3 files, or text files.
 A powerful macro language for recording and playing back keystrokes.
 Over seventy-five built-in business functions, like IRR and NPV.
 Automatic detection and diagnosis of errors or circular references.
}5%No matter how you work, no matter what your business,
Javelin is for you.
 Javelin's ten views provide ten different ways to analyze information.
 Javelin helps you build reports in seconds.
 Javelin helps you communicate your assumptions simply and effectively.
 Javelin is self-documenting, so it virtually eliminates errors.
 Javelin's menus and SPELL key make it easy to learn and use.
&Javelin
}0&A revolution in business analysis and reporting.
Press [Esc] to return to DOS,
or press [Space] to begin the
demonstration again.